﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_GetUserByCredentials')
	BEGIN
		DROP  Procedure  [esf_sso].P_GetUserByCredentials
	END

GO

CREATE Procedure [esf_sso].P_GetUserByCredentials
	@pAlias		VARCHAR (20)
	,@pPassword	VARCHAR (160)
AS

	SELECT 
		VU.*
	FROM
		[esf_sso].VUser VU
	WHERE
		VU.Usr_Alias = @pAlias
		AND VU.Usr_Password = @pPassword
		

GO